IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'tb_Utility_Asset_Distribution_PhasesXPole') 
AND name = N'IDX_tb_Utility_Asset_Distribution_PhasesXPole_Utility_Asset_DistributionFk')
	DROP INDEX IDX_tb_Utility_Asset_Distribution_PhasesXPole_Utility_Asset_DistributionFk ON tb_Utility_Asset_Distribution_PhasesXPole WITH ( ONLINE = OFF )

CREATE NONCLUSTERED INDEX IDX_tb_Utility_Asset_Distribution_PhasesXPole_Utility_Asset_DistributionFk ON tb_Utility_Asset_Distribution_PhasesXPole
(
	Utility_Asset_DistributionFk
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
 

